CREATE FUNCTION [dbo].[Split](@LocationIds varchar(8000), @seperator char(1))          
returns @temptable TABLE (ids int)          
as          
begin          
    declare @idx int          
    declare @slice varchar(8000)          
         
    select @idx = 1          
        if len(@LocationIds)<1 or @LocationIds is null  return          
         
    while @idx!= 0          
    begin          
        set @idx = charindex(@seperator,@LocationIds)          
        if @idx!=0          
            set @slice = left(@LocationIds,@idx - 1)          
        else          
            set @slice = @LocationIds          
             
        if(len(@slice)>0)     
            insert into @temptable(ids) values(@slice)          
    
        set @LocationIds = right(@LocationIds,len(@LocationIds) - @idx)          
        if len(@LocationIds) = 0 break          
    end      
return          
end   